Airbnb Booking

Dataset statistics

Number of variables	32
Number of observations	122636
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	29.5 MiB
Average record size in memory	252.0 B

Variable types

Numeric	20
Categorical	12

Alerts

`id` has a high cardinality: 122636 distinct values	High cardinality
`df_index` is highly correlated with `year_first_active` and 1 other fields	High correlation
`days_from_first_active_until_booking` is highly correlated with `days_from_account_created_until_first_booking` and 3 other fields	High correlation
`days_from_account_created_until_first_booking` is highly correlated with `days_from_first_active_until_booking` and 3 other fields	High correlation
`year_first_active` is highly correlated with `df_index` and 1 other fields	High correlation
`month_first_active` is highly correlated with `week_of_year_first_active` and 2 other fields	High correlation
`day_first_active` is highly correlated with `day_account_created`	High correlation
`day_of_week_first_active` is highly correlated with `day_of_week_account_created`	High correlation
`week_of_year_first_active` is highly correlated with `month_first_active` and 2 other fields	High correlation
`year_first_booking` is highly correlated with `days_from_first_active_until_booking` and 3 other fields	High correlation
`month_first_booking` is highly correlated with `week_of_year_first_booking`	High correlation
`day_first_booking` is highly correlated with `days_from_first_active_until_booking` and 3 other fields	High correlation
`day_of_week_first_booking` is highly correlated with `days_from_first_active_until_booking` and 3 other fields	High correlation
`week_of_year_first_booking` is highly correlated with `month_first_booking`	High correlation
`year_account_created` is highly correlated with `df_index` and 1 other fields	High correlation
`month_account_created` is highly correlated with `month_first_active` and 2 other fields	High correlation
`day_account_created` is highly correlated with `day_first_active`	High correlation
`day_of_week_account_created` is highly correlated with `day_of_week_first_active`	High correlation
`week_of_year_account_created` is highly correlated with `month_first_active` and 2 other fields	High correlation
`df_index` is highly correlated with `year_first_active` and 1 other fields	High correlation
`days_from_first_active_until_booking` is highly correlated with `days_from_account_created_until_first_booking` and 3 other fields	High correlation
`days_from_account_created_until_first_booking` is highly correlated with `days_from_first_active_until_booking` and 3 other fields	High correlation
`year_first_active` is highly correlated with `df_index` and 1 other fields	High correlation
`month_first_active` is highly correlated with `week_of_year_first_active` and 2 other fields	High correlation
`day_first_active` is highly correlated with `day_account_created`	High correlation
`day_of_week_first_active` is highly correlated with `day_of_week_account_created`	High correlation
`week_of_year_first_active` is highly correlated with `month_first_active` and 2 other fields	High correlation
`year_first_booking` is highly correlated with `days_from_first_active_until_booking` and 3 other fields	High correlation
`month_first_booking` is highly correlated with `week_of_year_first_booking`	High correlation
`day_first_booking` is highly correlated with `days_from_first_active_until_booking` and 3 other fields	High correlation
`day_of_week_first_booking` is highly correlated with `days_from_first_active_until_booking` and 3 other fields	High correlation
`week_of_year_first_booking` is highly correlated with `month_first_booking`	High correlation
`year_account_created` is highly correlated with `df_index` and 1 other fields	High correlation
`month_account_created` is highly correlated with `month_first_active` and 2 other fields	High correlation
`day_account_created` is highly correlated with `day_first_active`	High correlation
`day_of_week_account_created` is highly correlated with `day_of_week_first_active`	High correlation
`week_of_year_account_created` is highly correlated with `month_first_active` and 2 other fields	High correlation
`df_index` is highly correlated with `year_first_active` and 1 other fields	High correlation
`days_from_first_active_until_booking` is highly correlated with `days_from_account_created_until_first_booking` and 2 other fields	High correlation
`days_from_account_created_until_first_booking` is highly correlated with `days_from_first_active_until_booking` and 2 other fields	High correlation
`year_first_active` is highly correlated with `df_index` and 1 other fields	High correlation
`month_first_active` is highly correlated with `week_of_year_first_active` and 2 other fields	High correlation
`day_first_active` is highly correlated with `day_account_created`	High correlation
`day_of_week_first_active` is highly correlated with `day_of_week_account_created`	High correlation
`week_of_year_first_active` is highly correlated with `month_first_active` and 2 other fields	High correlation
`year_first_booking` is highly correlated with `days_from_first_active_until_booking` and 3 other fields	High correlation
`month_first_booking` is highly correlated with `week_of_year_first_booking`	High correlation
`day_first_booking` is highly correlated with `year_first_booking` and 1 other fields	High correlation
`day_of_week_first_booking` is highly correlated with `days_from_first_active_until_booking` and 3 other fields	High correlation
`week_of_year_first_booking` is highly correlated with `month_first_booking`	High correlation
`year_account_created` is highly correlated with `df_index` and 1 other fields	High correlation
`month_account_created` is highly correlated with `month_first_active` and 2 other fields	High correlation
`day_account_created` is highly correlated with `day_first_active`	High correlation
`day_of_week_account_created` is highly correlated with `day_of_week_first_active`	High correlation
`week_of_year_account_created` is highly correlated with `month_first_active` and 2 other fields	High correlation
`signup_app` is highly correlated with `first_device_type`	High correlation
`first_browser` is highly correlated with `first_device_type`	High correlation
`affiliate_channel` is highly correlated with `affiliate_provider`	High correlation
`affiliate_provider` is highly correlated with `affiliate_channel`	High correlation
`first_device_type` is highly correlated with `signup_app` and 1 other fields	High correlation
`df_index` is highly correlated with `days_from_first_active_until_booking` and 10 other fields	High correlation
`signup_flow` is highly correlated with `affiliate_channel` and 4 other fields	High correlation
`affiliate_channel` is highly correlated with `signup_flow` and 3 other fields	High correlation
`affiliate_provider` is highly correlated with `signup_flow` and 2 other fields	High correlation
`first_affiliate_tracked` is highly correlated with `affiliate_channel` and 1 other fields	High correlation
`signup_app` is highly correlated with `signup_flow` and 3 other fields	High correlation
`first_device_type` is highly correlated with `signup_flow` and 2 other fields	High correlation
`first_browser` is highly correlated with `signup_flow` and 2 other fields	High correlation
`country_destination` is highly correlated with `days_from_first_active_until_booking` and 6 other fields	High correlation
`days_from_first_active_until_booking` is highly correlated with `df_index` and 13 other fields	High correlation
`days_from_account_created_until_first_booking` is highly correlated with `df_index` and 9 other fields	High correlation
`year_first_active` is highly correlated with `df_index` and 8 other fields	High correlation
`month_first_active` is highly correlated with `df_index` and 8 other fields	High correlation
`day_first_active` is highly correlated with `day_first_booking` and 1 other fields	High correlation
`day_of_week_first_active` is highly correlated with `day_of_week_account_created`	High correlation
`week_of_year_first_active` is highly correlated with `df_index` and 8 other fields	High correlation
`year_first_booking` is highly correlated with `df_index` and 9 other fields	High correlation
`month_first_booking` is highly correlated with `df_index` and 11 other fields	High correlation
`day_first_booking` is highly correlated with `country_destination` and 8 other fields	High correlation
`day_of_week_first_booking` is highly correlated with `country_destination` and 6 other fields	High correlation
`week_of_year_first_booking` is highly correlated with `df_index` and 11 other fields	High correlation
`year_account_created` is highly correlated with `df_index` and 8 other fields	High correlation
`month_account_created` is highly correlated with `df_index` and 8 other fields	High correlation
`day_account_created` is highly correlated with `day_first_active` and 1 other fields	High correlation
`day_of_week_account_created` is highly correlated with `day_of_week_first_active`	High correlation
`week_of_year_account_created` is highly correlated with `df_index` and 8 other fields	High correlation
`days_from_first_active_until_account_created` is highly skewed (γ1 = 55.3260477)	Skewed
`id` is uniformly distributed	Uniform
`df_index` has unique values	Unique
`id` has unique values	Unique
`signup_flow` has 98317 (80.2%) zeros	Zeros
`days_from_first_active_until_booking` has 14839 (12.1%) zeros	Zeros
`days_from_first_active_until_account_created` has 122482 (99.9%) zeros	Zeros
`days_from_account_created_until_first_booking` has 14842 (12.1%) zeros	Zeros
`day_of_week_first_active` has 18958 (15.5%) zeros	Zeros
`day_of_week_first_booking` has 64567 (52.6%) zeros	Zeros
`day_of_week_account_created` has 18949 (15.5%) zeros	Zeros

Reproduction

Analysis started	2022-09-24 10:13:40.534024
Analysis finished	2022-09-24 10:14:55.408386
Duration	1 minute and 14.87 seconds
Software version	pandas-profiling v3.2.0
Download configuration	config.json

df_index
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
UNIQUE

Distinct	122636
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	104123.6797

Minimum	1
Maximum	213448
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	958.2 KiB

Quantile statistics

Minimum	1
5-th percentile	11367.5
Q1	50493.5
median	100991.5
Q3	158162.25
95-th percentile	202360.25
Maximum	213448
Range	213447
Interquartile range (IQR)	107668.75

Descriptive statistics

Standard deviation	61722.63315
Coefficient of variation (CV)	0.5927819042
Kurtosis	-1.218367405
Mean	104123.6797
Median Absolute Deviation (MAD)	53548
Skewness	0.07863645755
Sum	1.276931159 × 10¹⁰
Variance	3809683443
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1	< 0.1%
139171	1	< 0.1%
139197	1	< 0.1%
139196	1	< 0.1%
139193	1	< 0.1%
139192	1	< 0.1%
139191	1	< 0.1%
139190	1	< 0.1%
139188	1	< 0.1%
139186	1	< 0.1%
Other values (122626)	122626	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%
11	1	< 0.1%

Value	Count	Frequency (%)
213448	1	< 0.1%
213446	1	< 0.1%
213445	1	< 0.1%
213443	1	< 0.1%
213441	1	< 0.1%
213440	1	< 0.1%
213439	1	< 0.1%
213432	1	< 0.1%
213430	1	< 0.1%
213425	1	< 0.1%

id
Categorical

HIGH CARDINALITY
UNIFORM
UNIQUE

Distinct	122636
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	958.2 KiB

820tgsjxq7	1
upghc731x8	1
2ajt2i0cwf	1
dpsojmdsqa	1
aennz2le8b	1
Other values (122631)	122631

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	1226360
Distinct characters	36
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	122636 ?
Unique (%)	100.0%

Sample

1st row	820tgsjxq7
2nd row	4ft3gnwmtx
3rd row	bjjt8pjhuk
4th row	87mebub9p4
5th row	lsw9q7uk0j

Common Values

Value	Count	Frequency (%)
820tgsjxq7	1	< 0.1%
upghc731x8	1	< 0.1%
2ajt2i0cwf	1	< 0.1%
dpsojmdsqa	1	< 0.1%
aennz2le8b	1	< 0.1%
facfeibe4t	1	< 0.1%
t0hkswek7a	1	< 0.1%
z329kp10k2	1	< 0.1%
pz9eb42i12	1	< 0.1%
fqdedvewn8	1	< 0.1%
Other values (122626)	122626	> 99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
820tgsjxq7	1	< 0.1%
7i49vnuav6	1	< 0.1%
lsw9q7uk0j	1	< 0.1%
0d01nltbrs	1	< 0.1%
a1vcnhxeij	1	< 0.1%
6uh8zyj2gn	1	< 0.1%
yuuqmid2rp	1	< 0.1%
om1ss59ys8	1	< 0.1%
dy3rgx56cu	1	< 0.1%
ju3h98ch3w	1	< 0.1%
Other values (122626)	122626	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
h	34387	2.8%
y	34362	2.8%
l	34304	2.8%
t	34296	2.8%
a	34266	2.8%
k	34260	2.8%
f	34258	2.8%
4	34219	2.8%
9	34152	2.8%
m	34134	2.8%
Other values (26)	883722	72.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	885988	72.2%
Decimal Number	340372	27.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
h	34387	3.9%
y	34362	3.9%
l	34304	3.9%
t	34296	3.9%
a	34266	3.9%
k	34260	3.9%
f	34258	3.9%
m	34134	3.9%
x	34133	3.9%
d	34117	3.9%
Other values (16)	543471	61.3%

Decimal Number

Value	Count	Frequency (%)
4	34219	10.1%
9	34152	10.0%
3	34085	10.0%
0	34054	10.0%
7	34044	10.0%
5	34031	10.0%
8	34026	10.0%
1	34022	10.0%
2	34010	10.0%
6	33729	9.9%

Most occurring scripts

Value	Count	Frequency (%)
Latin	885988	72.2%
Common	340372	27.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
h	34387	3.9%
y	34362	3.9%
l	34304	3.9%
t	34296	3.9%
a	34266	3.9%
k	34260	3.9%
f	34258	3.9%
m	34134	3.9%
x	34133	3.9%
d	34117	3.9%
Other values (16)	543471	61.3%

Common

Value	Count	Frequency (%)
4	34219	10.1%
9	34152	10.0%
3	34085	10.0%
0	34054	10.0%
7	34044	10.0%
5	34031	10.0%
8	34026	10.0%
1	34022	10.0%
2	34010	10.0%
6	33729	9.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1226360	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
h	34387	2.8%
y	34362	2.8%
l	34304	2.8%
t	34296	2.8%
a	34266	2.8%
k	34260	2.8%
f	34258	2.8%
4	34219	2.8%
9	34152	2.8%
m	34134	2.8%
Other values (26)	883722	72.1%

gender
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	958.2 KiB

FEMALE	56362
MALE	49484
-unknown-	16565
OTHER	225

Length

Max length	9
Median length	6
Mean length	5.596382791
Min length	4

Characters and Unicode

Total characters	686318
Distinct characters	15
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	MALE
2nd row	FEMALE
3rd row	FEMALE
4th row	-unknown-
5th row	FEMALE

Common Values

Value	Count	Frequency (%)
FEMALE	56362	46.0%
MALE	49484	40.4%
-unknown-	16565	13.5%
OTHER	225	0.2%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
female	56362	46.0%
male	49484	40.4%
unknown	16565	13.5%
other	225	0.2%

Most occurring characters

Value	Count	Frequency (%)
E	162433	23.7%
M	105846	15.4%
A	105846	15.4%
L	105846	15.4%
F	56362	8.2%
n	49695	7.2%
-	33130	4.8%
u	16565	2.4%
k	16565	2.4%
o	16565	2.4%
Other values (5)	17465	2.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	537233	78.3%
Lowercase Letter	115955	16.9%
Dash Punctuation	33130	4.8%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	162433	30.2%
M	105846	19.7%
A	105846	19.7%
L	105846	19.7%
F	56362	10.5%
O	225	< 0.1%
T	225	< 0.1%
H	225	< 0.1%
R	225	< 0.1%

Lowercase Letter

Value	Count	Frequency (%)
n	49695	42.9%
u	16565	14.3%
k	16565	14.3%
o	16565	14.3%
w	16565	14.3%

Dash Punctuation

Value	Count	Frequency (%)
-	33130	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	653188	95.2%
Common	33130	4.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	162433	24.9%
M	105846	16.2%
A	105846	16.2%
L	105846	16.2%
F	56362	8.6%
n	49695	7.6%
u	16565	2.5%
k	16565	2.5%
o	16565	2.5%
w	16565	2.5%
Other values (4)	900	0.1%

Common

Value	Count	Frequency (%)
-	33130	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	686318	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	162433	23.7%
M	105846	15.4%
A	105846	15.4%
L	105846	15.4%
F	56362	8.2%
n	49695	7.2%
-	33130	4.8%
u	16565	2.4%
k	16565	2.4%
o	16565	2.4%
Other values (5)	17465	2.5%

age
Real number (ℝ_≥0)

Distinct	99
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	37.40559053

Minimum	16
Maximum	115
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	479.2 KiB

Quantile statistics

Minimum	16
5-th percentile	23
Q1	28
median	34
Q3	43
95-th percentile	63
Maximum	115
Range	99
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	13.93990034
Coefficient of variation (CV)	0.3726689016
Kurtosis	6.51646808
Mean	37.40559053
Median Absolute Deviation (MAD)	7
Skewness	2.089718287
Sum	4587272
Variance	194.3208214
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
30	6039	4.9%
31	5935	4.8%
29	5894	4.8%
28	5862	4.8%
32	5763	4.7%
27	5671	4.6%
33	5455	4.4%
26	4960	4.0%
34	4940	4.0%
35	4777	3.9%
Other values (89)	67340	54.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
16	26	< 0.1%
17	64	0.1%
18	665	0.5%
19	1097	0.9%
20	533	0.4%
21	969	0.8%
22	1679	1.4%
23	2424	2.0%
24	3173	2.6%
25	4405	3.6%

Value	Count	Frequency (%)
115	12	< 0.1%
113	4	< 0.1%
112	1	< 0.1%
111	2	< 0.1%
110	188	0.2%
109	31	< 0.1%
108	15	< 0.1%
107	23	< 0.1%
106	17	< 0.1%
105	1127	0.9%

signup_method
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	958.2 KiB

basic	66039
facebook	56456
google	141

Length

Max length	8
Median length	5
Mean length	6.382212401
Min length	5

Characters and Unicode

Total characters	782689
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	facebook
2nd row	basic
3rd row	facebook
4th row	basic
5th row	basic

Common Values

Value	Count	Frequency (%)
basic	66039	53.8%
facebook	56456	46.0%
google	141	0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
basic	66039	53.8%
facebook	56456	46.0%
google	141	0.1%

Most occurring characters

Value	Count	Frequency (%)
b	122495	15.7%
a	122495	15.7%
c	122495	15.7%
o	113194	14.5%
s	66039	8.4%
i	66039	8.4%
e	56597	7.2%
f	56456	7.2%
k	56456	7.2%
g	282	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	782689	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
b	122495	15.7%
a	122495	15.7%
c	122495	15.7%
o	113194	14.5%
s	66039	8.4%
i	66039	8.4%
e	56597	7.2%
f	56456	7.2%
k	56456	7.2%
g	282	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	782689	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
b	122495	15.7%
a	122495	15.7%
c	122495	15.7%
o	113194	14.5%
s	66039	8.4%
i	66039	8.4%
e	56597	7.2%
f	56456	7.2%
k	56456	7.2%
g	282	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	782689	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
b	122495	15.7%
a	122495	15.7%
c	122495	15.7%
o	113194	14.5%
s	66039	8.4%
i	66039	8.4%
e	56597	7.2%
f	56456	7.2%
k	56456	7.2%
g	282	< 0.1%

signup_flow
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	17
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.51951303

Minimum	0
Maximum	25
Zeros	98317
Zeros (%)	80.2%
Negative	0
Negative (%)	0.0%
Memory size	958.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	24
Maximum	25
Range	25
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	6.604722668
Coefficient of variation (CV)	2.621428263
Kurtosis	5.928297912
Mean	2.51951303
Median Absolute Deviation (MAD)	0
Skewness	2.705870564
Sum	308983
Variance	43.62236152
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
0	98317	80.2%
12	5996	4.9%
25	5845	4.8%
3	5035	4.1%
2	3823	3.1%
24	1596	1.3%
23	993	0.8%
1	509	0.4%
21	195	0.2%
8	142	0.1%
Other values (7)	185	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	98317	80.2%
1	509	0.4%
2	3823	3.1%
3	5035	4.1%
4	1	< 0.1%
5	27	< 0.1%
6	139	0.1%
8	142	0.1%
10	1	< 0.1%
12	5996	4.9%

Value	Count	Frequency (%)
25	5845	4.8%
24	1596	1.3%
23	993	0.8%
21	195	0.2%
20	5	< 0.1%
16	9	< 0.1%
15	3	< 0.1%
12	5996	4.9%
10	1	< 0.1%
8	142	0.1%

language
Categorical

Distinct	25
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	958.2 KiB

en	118205
zh	901
fr	807
es	625
de	407
Other values (20)	1691

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	245272
Distinct characters	19
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	en
2nd row	en
3rd row	en
4th row	en
5th row	en

Common Values

Value	Count	Frequency (%)
en	118205	96.4%
zh	901	0.7%
fr	807	0.7%
es	625	0.5%
de	407	0.3%
ko	395	0.3%
it	347	0.3%
ru	269	0.2%
pt	169	0.1%
ja	130	0.1%
Other values (15)	381	0.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
en	118205	96.4%
zh	901	0.7%
fr	807	0.7%
es	625	0.5%
de	407	0.3%
ko	395	0.3%
it	347	0.3%
ru	269	0.2%
pt	169	0.1%
ja	130	0.1%
Other values (15)	381	0.3%

Most occurring characters

Value	Count	Frequency (%)
e	119259	48.6%
n	118277	48.2%
r	1123	0.5%
h	935	0.4%
z	901	0.4%
f	818	0.3%
s	726	0.3%
t	578	0.2%
d	457	0.2%
o	415	0.2%
Other values (9)	1783	0.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	245272	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	119259	48.6%
n	118277	48.2%
r	1123	0.5%
h	935	0.4%
z	901	0.4%
f	818	0.3%
s	726	0.3%
t	578	0.2%
d	457	0.2%
o	415	0.2%
Other values (9)	1783	0.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	245272	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	119259	48.6%
n	118277	48.2%
r	1123	0.5%
h	935	0.4%
z	901	0.4%
f	818	0.3%
s	726	0.3%
t	578	0.2%
d	457	0.2%
o	415	0.2%
Other values (9)	1783	0.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	245272	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	119259	48.6%
n	118277	48.2%
r	1123	0.5%
h	935	0.4%
z	901	0.4%
f	818	0.3%
s	726	0.3%
t	578	0.2%
d	457	0.2%
o	415	0.2%
Other values (9)	1783	0.7%

affiliate_channel
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	958.2 KiB

direct	79093
sem-brand	15347
sem-non-brand	9677
other	5357
seo	5288
Other values (3)	7874

Length

Max length	13
Median length	6
Mean length	6.666109462
Min length	3

Characters and Unicode

Total characters	817505
Distinct characters	17
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	seo
2nd row	direct
3rd row	direct
4th row	direct
5th row	other

Common Values

Value	Count	Frequency (%)
direct	79093	64.5%
sem-brand	15347	12.5%
sem-non-brand	9677	7.9%
other	5357	4.4%
seo	5288	4.3%
api	5280	4.3%
content	2000	1.6%
remarketing	594	0.5%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
direct	79093	64.5%
sem-brand	15347	12.5%
sem-non-brand	9677	7.9%
other	5357	4.4%
seo	5288	4.3%
api	5280	4.3%
content	2000	1.6%
remarketing	594	0.5%

Most occurring characters

Value	Count	Frequency (%)
e	117950	14.4%
r	110662	13.5%
d	104117	12.7%
t	89044	10.9%
i	84967	10.4%
c	81093	9.9%
n	48972	6.0%
-	34701	4.2%
a	30898	3.8%
s	30312	3.7%
Other values (7)	84789	10.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	782804	95.8%
Dash Punctuation	34701	4.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	117950	15.1%
r	110662	14.1%
d	104117	13.3%
t	89044	11.4%
i	84967	10.9%
c	81093	10.4%
n	48972	6.3%
a	30898	3.9%
s	30312	3.9%
m	25618	3.3%
Other values (6)	59171	7.6%

Dash Punctuation

Value	Count	Frequency (%)
-	34701	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	782804	95.8%
Common	34701	4.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	117950	15.1%
r	110662	14.1%
d	104117	13.3%
t	89044	11.4%
i	84967	10.9%
c	81093	10.4%
n	48972	6.3%
a	30898	3.9%
s	30312	3.9%
m	25618	3.3%
Other values (6)	59171	7.6%

Common

Value	Count	Frequency (%)
-	34701	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	817505	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	117950	14.4%
r	110662	13.5%
d	104117	12.7%
t	89044	10.9%
i	84967	10.4%
c	81093	9.9%
n	48972	6.0%
-	34701	4.2%
a	30898	3.8%
s	30312	3.7%
Other values (7)	84789	10.4%

affiliate_provider
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	17
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	958.2 KiB

direct	78954
google	29062
other	7930
craigslist	2027
facebook	1568
Other values (12)	3095

Length

Max length	19
Median length	6
Mean length	6.056003131
Min length	3

Characters and Unicode

Total characters	742684
Distinct characters	24
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	google
2nd row	direct
3rd row	direct
4th row	direct
5th row	craigslist

Common Values

Value	Count	Frequency (%)
direct	78954	64.4%
google	29062	23.7%
other	7930	6.5%
craigslist	2027	1.7%
facebook	1568	1.3%
bing	1159	0.9%
padmapper	463	0.4%
facebook-open-graph	409	0.3%
vast	350	0.3%
yahoo	251	0.2%
Other values (7)	463	0.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
direct	78954	64.4%
google	29062	23.7%
other	7930	6.5%
craigslist	2027	1.7%
facebook	1568	1.3%
bing	1159	0.9%
padmapper	463	0.4%
facebook-open-graph	409	0.3%
vast	350	0.3%
yahoo	251	0.2%
Other values (7)	463	0.4%

Most occurring characters

Value	Count	Frequency (%)
e	119274	16.1%
r	89890	12.1%
t	89480	12.0%
i	84342	11.4%
c	82958	11.2%
d	79446	10.7%
o	70919	9.5%
g	61984	8.3%
l	31169	4.2%
h	8590	1.2%
Other values (14)	24632	3.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	741786	99.9%
Dash Punctuation	898	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	119274	16.1%
r	89890	12.1%
t	89480	12.1%
i	84342	11.4%
c	82958	11.2%
d	79446	10.7%
o	70919	9.6%
g	61984	8.4%
l	31169	4.2%
h	8590	1.2%
Other values (13)	23734	3.2%

Dash Punctuation

Value	Count	Frequency (%)
-	898	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	741786	99.9%
Common	898	0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	119274	16.1%
r	89890	12.1%
t	89480	12.1%
i	84342	11.4%
c	82958	11.2%
d	79446	10.7%
o	70919	9.6%
g	61984	8.4%
l	31169	4.2%
h	8590	1.2%
Other values (13)	23734	3.2%

Common

Value	Count	Frequency (%)
-	898	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	742684	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	119274	16.1%
r	89890	12.1%
t	89480	12.0%
i	84342	11.4%
c	82958	11.2%
d	79446	10.7%
o	70919	9.5%
g	61984	8.3%
l	31169	4.2%
h	8590	1.2%
Other values (14)	24632	3.3%

first_affiliate_tracked
Categorical

HIGH CORRELATION

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	958.2 KiB

untracked	64712
linked	28284
omg	24865
tracked-other	3834
product	813
Other values (2)	128

Length

Max length	13
Median length	9
Mean length	7.203366059
Min length	3

Characters and Unicode

Total characters	883392
Distinct characters	19
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	untracked
2nd row	untracked
3rd row	untracked
4th row	untracked
5th row	untracked

Common Values

Value	Count	Frequency (%)
untracked	64712	52.8%
linked	28284	23.1%
omg	24865	20.3%
tracked-other	3834	3.1%
product	813	0.7%
marketing	101	0.1%
local ops	27	< 0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
untracked	64712	52.8%
linked	28284	23.1%
omg	24865	20.3%
tracked-other	3834	3.1%
product	813	0.7%
marketing	101	0.1%
local	27	< 0.1%
ops	27	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
e	100765	11.4%
d	97643	11.1%
k	96931	11.0%
n	93097	10.5%
t	73294	8.3%
r	73294	8.3%
c	69386	7.9%
a	68674	7.8%
u	65525	7.4%
o	29566	3.3%
Other values (9)	115217	13.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	879531	99.6%
Dash Punctuation	3834	0.4%
Space Separator	27	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	100765	11.5%
d	97643	11.1%
k	96931	11.0%
n	93097	10.6%
t	73294	8.3%
r	73294	8.3%
c	69386	7.9%
a	68674	7.8%
u	65525	7.4%
o	29566	3.4%
Other values (7)	111356	12.7%

Dash Punctuation

Value	Count	Frequency (%)
-	3834	100.0%

Space Separator

Value	Count	Frequency (%)
	27	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	879531	99.6%
Common	3861	0.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	100765	11.5%
d	97643	11.1%
k	96931	11.0%
n	93097	10.6%
t	73294	8.3%
r	73294	8.3%
c	69386	7.9%
a	68674	7.8%
u	65525	7.4%
o	29566	3.4%
Other values (7)	111356	12.7%

Common

Value	Count	Frequency (%)
-	3834	99.3%
	27	0.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	883392	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	100765	11.4%
d	97643	11.1%
k	96931	11.0%
n	93097	10.5%
t	73294	8.3%
r	73294	8.3%
c	69386	7.9%
a	68674	7.8%
u	65525	7.4%
o	29566	3.3%
Other values (9)	115217	13.0%

signup_app
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	958.2 KiB

Web	108283
iOS	9689
Moweb	2364
Android	2300

Length

Max length	7
Median length	3
Mean length	3.113571871
Min length	3

Characters and Unicode

Total characters	381836
Distinct characters	13
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Web
2nd row	Web
3rd row	Web
4th row	Web
5th row	Web

Common Values

Value	Count	Frequency (%)
Web	108283	88.3%
iOS	9689	7.9%
Moweb	2364	1.9%
Android	2300	1.9%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
web	108283	88.3%
ios	9689	7.9%
moweb	2364	1.9%
android	2300	1.9%

Most occurring characters

Value	Count	Frequency (%)
e	110647	29.0%
b	110647	29.0%
W	108283	28.4%
i	11989	3.1%
O	9689	2.5%
S	9689	2.5%
o	4664	1.2%
d	4600	1.2%
M	2364	0.6%
w	2364	0.6%
Other values (3)	6900	1.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	249511	65.3%
Uppercase Letter	132325	34.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	110647	44.3%
b	110647	44.3%
i	11989	4.8%
o	4664	1.9%
d	4600	1.8%
w	2364	0.9%
n	2300	0.9%
r	2300	0.9%

Uppercase Letter

Value	Count	Frequency (%)
W	108283	81.8%
O	9689	7.3%
S	9689	7.3%
M	2364	1.8%
A	2300	1.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	381836	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	110647	29.0%
b	110647	29.0%
W	108283	28.4%
i	11989	3.1%
O	9689	2.5%
S	9689	2.5%
o	4664	1.2%
d	4600	1.2%
M	2364	0.6%
w	2364	0.6%
Other values (3)	6900	1.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	381836	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	110647	29.0%
b	110647	29.0%
W	108283	28.4%
i	11989	3.1%
O	9689	2.5%
S	9689	2.5%
o	4664	1.2%
d	4600	1.2%
M	2364	0.6%
w	2364	0.6%
Other values (3)	6900	1.8%

first_device_type
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	958.2 KiB

Mac Desktop	57943
Windows Desktop	41828
iPhone	10528
iPad	7635
Other/Unknown	2003
Other values (4)	2699

Length

Max length	18
Median length	15
Mean length	11.59511073
Min length	4

Characters and Unicode

Total characters	1421978
Distinct characters	30
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Mac Desktop
2nd row	Windows Desktop
3rd row	Mac Desktop
4th row	Mac Desktop
5th row	Mac Desktop

Common Values

Value	Count	Frequency (%)
Mac Desktop	57943	47.2%
Windows Desktop	41828	34.1%
iPhone	10528	8.6%
iPad	7635	6.2%
Other/Unknown	2003	1.6%
Android Phone	1257	1.0%
Desktop (Other)	753	0.6%
Android Tablet	650	0.5%
SmartPhone (Other)	39	< 0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
desktop	100524	44.7%
mac	57943	25.7%
windows	41828	18.6%
iphone	10528	4.7%
ipad	7635	3.4%
other/unknown	2003	0.9%
android	1907	0.8%
phone	1257	0.6%
other	792	0.4%
tablet	650	0.3%

Most occurring characters

Value	Count	Frequency (%)
o	158086	11.1%
s	142352	10.0%
e	115793	8.1%
t	104008	7.3%
k	102527	7.2%
	102470	7.2%
D	100524	7.1%
p	100524	7.1%
a	66267	4.7%
i	61898	4.4%
Other values (20)	367529	25.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1088773	76.6%
Uppercase Letter	227148	16.0%
Space Separator	102470	7.2%
Other Punctuation	2003	0.1%
Open Punctuation	792	0.1%
Close Punctuation	792	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	158086	14.5%
s	142352	13.1%
e	115793	10.6%
t	104008	9.6%
k	102527	9.4%
p	100524	9.2%
a	66267	6.1%
i	61898	5.7%
n	61568	5.7%
c	57943	5.3%
Other values (7)	117807	10.8%

Uppercase Letter

Value	Count	Frequency (%)
D	100524	44.3%
M	57943	25.5%
W	41828	18.4%
P	19459	8.6%
O	2795	1.2%
U	2003	0.9%
A	1907	0.8%
T	650	0.3%
S	39	< 0.1%

Space Separator

Value	Count	Frequency (%)
	102470	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	2003	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	792	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	792	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1315921	92.5%
Common	106057	7.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	158086	12.0%
s	142352	10.8%
e	115793	8.8%
t	104008	7.9%
k	102527	7.8%
D	100524	7.6%
p	100524	7.6%
a	66267	5.0%
i	61898	4.7%
n	61568	4.7%
Other values (16)	302374	23.0%

Common

Value	Count	Frequency (%)
	102470	96.6%
/	2003	1.9%
(	792	0.7%
)	792	0.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1421978	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	158086	11.1%
s	142352	10.0%
e	115793	8.1%
t	104008	7.3%
k	102527	7.2%
	102470	7.2%
D	100524	7.1%
p	100524	7.1%
a	66267	4.7%
i	61898	4.4%
Other values (20)	367529	25.8%

first_browser
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	41
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	958.2 KiB

Chrome	41778
Safari	27711
Firefox	20600
IE	10509
Mobile Safari	10333
Other values (36)	11705

Length

Max length	18
Median length	6
Mean length	6.739619688
Min length	2

Characters and Unicode

Total characters	826520
Distinct characters	46
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	6 ?
Unique (%)	< 0.1%

Sample

1st row	Chrome
2nd row	IE
3rd row	Firefox
4th row	Chrome
5th row	Safari

Common Values

Value	Count	Frequency (%)
Chrome	41778	34.1%
Safari	27711	22.6%
Firefox	20600	16.8%
IE	10509	8.6%
Mobile Safari	10333	8.4%
-unknown-	10115	8.2%
Chrome Mobile	602	0.5%
Android Browser	404	0.3%
Opera	113	0.1%
AOL Explorer	100	0.1%
Other values (31)	371	0.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
chrome	42380	31.6%
safari	38044	28.3%
firefox	20619	15.4%
mobile	10969	8.2%
ie	10522	7.8%
unknown	10115	7.5%
browser	446	0.3%
android	404	0.3%
opera	117	0.1%
explorer	113	0.1%
Other values (33)	469	0.3%

Most occurring characters

Value	Count	Frequency (%)
r	102853	12.4%
o	85272	10.3%
a	76335	9.2%
e	74816	9.1%
i	70230	8.5%
f	58663	7.1%
m	42498	5.1%
h	42464	5.1%
C	42446	5.1%
S	38152	4.6%
Other values (36)	192791	23.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	659797	79.8%
Uppercase Letter	134922	16.3%
Dash Punctuation	20230	2.4%
Space Separator	11562	1.4%
Other Punctuation	9	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	102853	15.6%
o	85272	12.9%
a	76335	11.6%
e	74816	11.3%
i	70230	10.6%
f	58663	8.9%
m	42498	6.4%
h	42464	6.4%
n	30829	4.7%
x	20775	3.1%
Other values (14)	55062	8.3%

Uppercase Letter

Value	Count	Frequency (%)
C	42446	31.5%
S	38152	28.3%
F	20631	15.3%
M	11055	8.2%
E	10635	7.9%
I	10545	7.8%
A	531	0.4%
B	527	0.4%
O	219	0.2%
L	100	0.1%
Other values (9)	81	0.1%

Dash Punctuation

Value	Count	Frequency (%)
-	20230	100.0%

Space Separator

Value	Count	Frequency (%)
	11562	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	9	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	794719	96.2%
Common	31801	3.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	102853	12.9%
o	85272	10.7%
a	76335	9.6%
e	74816	9.4%
i	70230	8.8%
f	58663	7.4%
m	42498	5.3%
h	42464	5.3%
C	42446	5.3%
S	38152	4.8%
Other values (33)	160990	20.3%

Common

Value	Count	Frequency (%)
-	20230	63.6%
	11562	36.4%
.	9	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	826520	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	102853	12.4%
o	85272	10.3%
a	76335	9.2%
e	74816	9.1%
i	70230	8.5%
f	58663	7.1%
m	42498	5.1%
h	42464	5.1%
C	42446	5.1%
S	38152	4.6%
Other values (36)	192791	23.3%

country_destination
Categorical

HIGH CORRELATION

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	958.2 KiB

NDF	54852
US	48057
other	7511
FR	3669
IT	2014
Other values (7)	6533

Length

Max length	5
Median length	3
Mean length	2.631013732
Min length	2

Characters and Unicode

Total characters	322657
Distinct characters	20
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	NDF
2nd row	US
3rd row	other
4th row	US
5th row	US

Common Values

Value	Count	Frequency (%)
NDF	54852	44.7%
US	48057	39.2%
other	7511	6.1%
FR	3669	3.0%
IT	2014	1.6%
GB	1758	1.4%
ES	1685	1.4%
CA	1064	0.9%
DE	841	0.7%
NL	595	0.5%
Other values (2)	590	0.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ndf	54852	44.7%
us	48057	39.2%
other	7511	6.1%
fr	3669	3.0%
it	2014	1.6%
gb	1758	1.4%
es	1685	1.4%
ca	1064	0.9%
de	841	0.7%
nl	595	0.5%
Other values (2)	590	0.5%

Most occurring characters

Value	Count	Frequency (%)
F	58521	18.1%
D	55693	17.3%
N	55447	17.2%
S	49742	15.4%
U	48490	15.0%
o	7511	2.3%
t	7511	2.3%
h	7511	2.3%
e	7511	2.3%
r	7511	2.3%
Other values (10)	17209	5.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	285102	88.4%
Lowercase Letter	37555	11.6%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
F	58521	20.5%
D	55693	19.5%
N	55447	19.4%
S	49742	17.4%
U	48490	17.0%
R	3669	1.3%
E	2526	0.9%
T	2171	0.8%
I	2014	0.7%
G	1758	0.6%
Other values (5)	5071	1.8%

Lowercase Letter

Value	Count	Frequency (%)
o	7511	20.0%
t	7511	20.0%
h	7511	20.0%
e	7511	20.0%
r	7511	20.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	322657	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
F	58521	18.1%
D	55693	17.3%
N	55447	17.2%
S	49742	15.4%
U	48490	15.0%
o	7511	2.3%
t	7511	2.3%
h	7511	2.3%
e	7511	2.3%
r	7511	2.3%
Other values (10)	17209	5.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	322657	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
F	58521	18.1%
D	55693	17.3%
N	55447	17.2%
S	49742	15.4%
U	48490	15.0%
o	7511	2.3%
t	7511	2.3%
h	7511	2.3%
e	7511	2.3%
r	7511	2.3%
Other values (10)	17209	5.3%

days_from_first_active_until_booking
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	1853
Distinct (%)	1.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	356.2222104

Minimum	0
Maximum	2228
Zeros	14839
Zeros (%)	12.1%
Negative	0
Negative (%)	0.0%
Memory size	958.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	3
median	222
Q3	625
95-th percentile	1124
Maximum	2228
Range	2228
Interquartile range (IQR)	622

Descriptive statistics

Standard deviation	398.6656183
Coefficient of variation (CV)	1.119148685
Kurtosis	0.02666812209
Mean	356.2222104
Median Absolute Deviation (MAD)	221
Skewness	0.9379958696
Sum	43685667
Variance	158934.2752
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	14839	12.1%
1	10592	8.6%
2	4795	3.9%
3	2956	2.4%
4	2183	1.8%
5	1694	1.4%
6	1328	1.1%
7	1237	1.0%
8	992	0.8%
9	812	0.7%
Other values (1843)	81208	66.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	14839	12.1%
1	10592	8.6%
2	4795	3.9%
3	2956	2.4%
4	2183	1.8%
5	1694	1.4%
6	1328	1.1%
7	1237	1.0%
8	992	0.8%
9	812	0.7%

Value	Count	Frequency (%)
2228	1	< 0.1%
2001	2	< 0.1%
1999	1	< 0.1%
1995	1	< 0.1%
1992	1	< 0.1%
1991	2	< 0.1%
1990	2	< 0.1%
1980	1	< 0.1%
1979	1	< 0.1%
1977	1	< 0.1%

days_from_first_active_until_account_created
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	132
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.3723947291

Minimum	0
Maximum	1456
Zeros	122482
Zeros (%)	99.9%
Negative	0
Negative (%)	0.0%
Memory size	958.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	1456
Range	1456
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	15.17748441
Coefficient of variation (CV)	40.75644262
Kurtosis	3655.645933
Mean	0.3723947291
Median Absolute Deviation (MAD)	0
Skewness	55.3260477
Sum	45669
Variance	230.356033
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	122482	99.9%
1	4	< 0.1%
6	4	< 0.1%
3	3	< 0.1%
29	3	< 0.1%
634	2	< 0.1%
103	2	< 0.1%
4	2	< 0.1%
20	2	< 0.1%
722	2	< 0.1%
Other values (122)	130	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	122482	99.9%
1	4	< 0.1%
2	1	< 0.1%
3	3	< 0.1%
4	2	< 0.1%
5	2	< 0.1%
6	4	< 0.1%
7	1	< 0.1%
9	2	< 0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
1456	1	< 0.1%
1369	1	< 0.1%
1361	1	< 0.1%
1148	1	< 0.1%
1036	1	< 0.1%
1018	1	< 0.1%
1011	1	< 0.1%
995	1	< 0.1%
882	1	< 0.1%
851	1	< 0.1%

days_from_account_created_until_first_booking
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	1873
Distinct (%)	1.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	355.8498157

Minimum	-349
Maximum	2001
Zeros	14842
Zeros (%)	12.1%
Negative	25
Negative (%)	< 0.1%
Memory size	958.2 KiB

Quantile statistics

Minimum	-349
5-th percentile	0
Q1	3
median	221
Q3	624
95-th percentile	1123
Maximum	2001
Range	2350
Interquartile range (IQR)	621

Descriptive statistics

Standard deviation	398.4638995
Coefficient of variation (CV)	1.119753002
Kurtosis	0.02362103566
Mean	355.8498157
Median Absolute Deviation (MAD)	220
Skewness	0.9374490797
Sum	43639998
Variance	158773.4792
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	14842	12.1%
1	10592	8.6%
2	4799	3.9%
3	2958	2.4%
4	2183	1.8%
5	1698	1.4%
6	1331	1.1%
7	1237	1.0%
8	993	0.8%
9	810	0.7%
Other values (1863)	81193	66.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-349	1	< 0.1%
-347	1	< 0.1%
-338	1	< 0.1%
-308	1	< 0.1%
-298	1	< 0.1%
-295	1	< 0.1%
-269	1	< 0.1%
-261	1	< 0.1%
-208	1	< 0.1%
-140	1	< 0.1%

Value	Count	Frequency (%)
2001	2	< 0.1%
1999	1	< 0.1%
1995	1	< 0.1%
1992	1	< 0.1%
1991	2	< 0.1%
1990	2	< 0.1%
1980	1	< 0.1%
1979	1	< 0.1%
1977	1	< 0.1%
1976	1	< 0.1%

year_first_active
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2012.995474

Minimum	2009
Maximum	2014
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	958.2 KiB

Quantile statistics

Minimum	2009
5-th percentile	2011
Q1	2012
median	2013
Q3	2014
95-th percentile	2014
Maximum	2014
Range	5
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	0.9322921086
Coefficient of variation (CV)	0.0004631367137
Kurtosis	0.1130724671
Mean	2012.995474
Median Absolute Deviation (MAD)	1
Skewness	-0.7406306153
Sum	246865713
Variance	0.8691685758
Monotonicity	Increasing

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
2013	47612	38.8%
2014	42024	34.3%
2012	24833	20.2%
2011	6759	5.5%
2010	1404	1.1%
2009	4	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2009	4	< 0.1%
2010	1404	1.1%
2011	6759	5.5%
2012	24833	20.2%
2013	47612	38.8%
2014	42024	34.3%

Value	Count	Frequency (%)
2014	42024	34.3%
2013	47612	38.8%
2012	24833	20.2%
2011	6759	5.5%
2010	1404	1.1%
2009	4	< 0.1%

month_first_active
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.022375159

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	958.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	6
Q3	9
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.237443766
Coefficient of variation (CV)	0.5375692614
Kurtosis	-0.9597083204
Mean	6.022375159
Median Absolute Deviation (MAD)	3
Skewness	0.2566857032
Sum	738560
Variance	10.48104214
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
6	15792	12.9%
5	15097	12.3%
4	12802	10.4%
3	11475	9.4%
1	10044	8.2%
2	9463	7.7%
9	8524	7.0%
8	8317	6.8%
7	8033	6.6%
12	7876	6.4%
Other values (2)	15213	12.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	10044	8.2%
2	9463	7.7%
3	11475	9.4%
4	12802	10.4%
5	15097	12.3%
6	15792	12.9%
7	8033	6.6%
8	8317	6.8%
9	8524	7.0%
10	7618	6.2%

Value	Count	Frequency (%)
12	7876	6.4%
11	7595	6.2%
10	7618	6.2%
9	8524	7.0%
8	8317	6.8%
7	8033	6.6%
6	15792	12.9%
5	15097	12.3%
4	12802	10.4%
3	11475	9.4%

day_first_active
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.84833165

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	958.2 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	16
Q3	23
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.747048483
Coefficient of variation (CV)	0.5519223523
Kurtosis	-1.189734108
Mean	15.84833165
Median Absolute Deviation (MAD)	8
Skewness	-0.005730388422
Sum	1943576
Variance	76.51085717
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
24	4189	3.4%
16	4148	3.4%
23	4138	3.4%
18	4130	3.4%
20	4127	3.4%
28	4125	3.4%
27	4116	3.4%
12	4102	3.3%
11	4099	3.3%
10	4093	3.3%
Other values (21)	81369	66.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	3509	2.9%
2	3977	3.2%
3	3972	3.2%
4	3972	3.2%
5	4046	3.3%
6	4039	3.3%
7	3891	3.2%
8	3967	3.2%
9	4062	3.3%
10	4093	3.3%

Value	Count	Frequency (%)
31	2167	1.8%
30	3847	3.1%
29	3805	3.1%
28	4125	3.4%
27	4116	3.4%
26	4028	3.3%
25	3945	3.2%
24	4189	3.4%
23	4138	3.4%
22	4031	3.3%

day_of_week_first_active
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.756604912

Minimum	0
Maximum	6
Zeros	18958
Zeros (%)	15.5%
Negative	0
Negative (%)	0.0%
Memory size	958.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	3
Q3	4
95-th percentile	6
Maximum	6
Range	6
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.943487263
Coefficient of variation (CV)	0.7050293114
Kurtosis	-1.148441713
Mean	2.756604912
Median Absolute Deviation (MAD)	2
Skewness	0.1709459789
Sum	338059
Variance	3.777142741
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
1	20241	16.5%
2	19662	16.0%
0	18958	15.5%
3	18634	15.2%
4	17114	14.0%
5	14026	11.4%
6	14001	11.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	18958	15.5%
1	20241	16.5%
2	19662	16.0%
3	18634	15.2%
4	17114	14.0%
5	14026	11.4%
6	14001	11.4%

Value	Count	Frequency (%)
6	14001	11.4%
5	14026	11.4%
4	17114	14.0%
3	18634	15.2%
2	19662	16.0%
1	20241	16.5%
0	18958	15.5%

week_of_year_first_active
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	53
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.38784696

Minimum	1
Maximum	53
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	958.2 KiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	13
median	23
Q3	36
95-th percentile	49
Maximum	53
Range	52
Interquartile range (IQR)	23

Descriptive statistics

Standard deviation	14.02350956
Coefficient of variation (CV)	0.575020402
Kurtosis	-0.946019158
Mean	24.38784696
Median Absolute Deviation (MAD)	11
Skewness	0.2579501753
Sum	2990828
Variance	196.6588205
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
26	3985	3.2%
25	3691	3.0%
21	3636	3.0%
24	3622	3.0%
23	3585	2.9%
20	3493	2.8%
22	3328	2.7%
19	3248	2.6%
17	3242	2.6%
18	3240	2.6%
Other values (43)	87566	71.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1917	1.6%
2	2285	1.9%
3	2453	2.0%
4	2243	1.8%
5	2285	1.9%
6	2375	1.9%
7	2279	1.9%
8	2376	1.9%
9	2551	2.1%
10	2514	2.0%

Value	Count	Frequency (%)
53	2	< 0.1%
52	1654	1.3%
51	1713	1.4%
50	1753	1.4%
49	1970	1.6%
48	1740	1.4%
47	1762	1.4%
46	1862	1.5%
45	1824	1.5%
44	1632	1.3%

year_first_booking
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2013.952192

Minimum	2010
Maximum	2015
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	958.2 KiB

Quantile statistics

Minimum	2010
5-th percentile	2012
Q1	2013
median	2014
Q3	2015
95-th percentile	2015
Maximum	2015
Range	5
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.193405115
Coefficient of variation (CV)	0.0005925687412
Kurtosis	0.01502677947
Mean	2013.952192
Median Absolute Deviation (MAD)	1
Skewness	-0.9217506634
Sum	246983041
Variance	1.424215769
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
2015	56425	46.0%
2014	25800	21.0%
2013	23898	19.5%
2012	12021	9.8%
2011	3620	3.0%
2010	872	0.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2010	872	0.7%
2011	3620	3.0%
2012	12021	9.8%
2013	23898	19.5%
2014	25800	21.0%
2015	56425	46.0%

Value	Count	Frequency (%)
2015	56425	46.0%
2014	25800	21.0%
2013	23898	19.5%
2012	12021	9.8%
2011	3620	3.0%
2010	872	0.7%

month_first_booking
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.06548648

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	958.2 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	5
median	6
Q3	6
95-th percentile	11
Maximum	12
Range	11
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	2.371727504
Coefficient of variation (CV)	0.3910201616
Kurtosis	0.6889050134
Mean	6.06548648
Median Absolute Deviation (MAD)	0
Skewness	0.3180099436
Sum	743847
Variance	5.625091353
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
6	62939	51.3%
5	7954	6.5%
4	6684	5.5%
3	6297	5.1%
7	5574	4.5%
8	5339	4.4%
2	5114	4.2%
1	5055	4.1%
9	4988	4.1%
10	4693	3.8%
Other values (2)	7999	6.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	5055	4.1%
2	5114	4.2%
3	6297	5.1%
4	6684	5.5%
5	7954	6.5%
6	62939	51.3%
7	5574	4.5%
8	5339	4.4%
9	4988	4.1%
10	4693	3.8%

Value	Count	Frequency (%)
12	3992	3.3%
11	4007	3.3%
10	4693	3.8%
9	4988	4.1%
8	5339	4.4%
7	5574	4.5%
6	62939	51.3%
5	7954	6.5%
4	6684	5.5%
3	6297	5.1%

day_first_booking
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	21.61555334

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	958.2 KiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	14
median	28
Q3	29
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	9.283882799
Coefficient of variation (CV)	0.429500122
Kurtosis	-0.754697507
Mean	21.61555334
Median Absolute Deviation (MAD)	2
Skewness	-0.853826875
Sum	2650845
Variance	86.19047983
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
29	56857	46.4%
16	2344	1.9%
17	2328	1.9%
11	2321	1.9%
10	2318	1.9%
13	2313	1.9%
15	2300	1.9%
3	2291	1.9%
5	2284	1.9%
12	2280	1.9%
Other values (21)	45000	36.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	2104	1.7%
2	2189	1.8%
3	2291	1.9%
4	2161	1.8%
5	2284	1.9%
6	2228	1.8%
7	2259	1.8%
8	2272	1.9%
9	2212	1.8%
10	2318	1.9%

Value	Count	Frequency (%)
31	1194	1.0%
30	2055	1.7%
29	56857	46.4%
28	2157	1.8%
27	2098	1.7%
26	2149	1.8%
25	2195	1.8%
24	2219	1.8%
23	2212	1.8%
22	2234	1.8%

day_of_week_first_booking
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.549520532

Minimum	0
Maximum	6
Zeros	64567
Zeros (%)	52.6%
Negative	0
Negative (%)	0.0%
Memory size	958.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	3
95-th percentile	6
Maximum	6
Range	6
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.992697276
Coefficient of variation (CV)	1.286008952
Kurtosis	-0.4927185682
Mean	1.549520532
Median Absolute Deviation (MAD)	0
Skewness	0.9556386108
Sum	190027
Variance	3.970842433
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
0	64567	52.6%
1	10913	8.9%
2	10909	8.9%
3	10610	8.7%
4	10180	8.3%
5	7996	6.5%
6	7461	6.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	64567	52.6%
1	10913	8.9%
2	10909	8.9%
3	10610	8.7%
4	10180	8.3%
5	7996	6.5%
6	7461	6.1%

Value	Count	Frequency (%)
6	7461	6.1%
5	7996	6.5%
4	10180	8.3%
3	10610	8.7%
2	10909	8.9%
1	10913	8.9%
0	64567	52.6%

week_of_year_first_booking
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	52
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	25.7803826

Minimum	1
Maximum	52
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	958.2 KiB

Quantile statistics

Minimum	1
5-th percentile	6
Q1	22
median	27
Q3	27
95-th percentile	46
Maximum	52
Range	51
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	10.32728106
Coefficient of variation (CV)	0.4005868036
Kurtosis	0.5584607396
Mean	25.7803826
Median Absolute Deviation (MAD)	2
Skewness	-0.0328879698
Sum	3161603
Variance	106.6527341
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
27	56297	45.9%
26	1960	1.6%
24	1909	1.6%
21	1899	1.5%
20	1888	1.5%
25	1875	1.5%
23	1845	1.5%
18	1778	1.4%
19	1722	1.4%
22	1710	1.4%
Other values (42)	49753	40.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	863	0.7%
2	1128	0.9%
3	1399	1.1%
4	1129	0.9%
5	1119	0.9%
6	1257	1.0%
7	1333	1.1%
8	1291	1.1%
9	1330	1.1%
10	1416	1.2%

Value	Count	Frequency (%)
52	734	0.6%
51	910	0.7%
50	941	0.8%
49	1025	0.8%
48	891	0.7%
47	877	0.7%
46	933	0.8%
45	1072	0.9%
44	910	0.7%
43	968	0.8%

year_account_created
Categorical

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	958.2 KiB

2013	47619
2014	42059
2012	24820
2011	6743
2010	1395

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	490544
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2011
2nd row	2010
3rd row	2011
4th row	2010
5th row	2010

Common Values

Value	Count	Frequency (%)
2013	47619	38.8%
2014	42059	34.3%
2012	24820	20.2%
2011	6743	5.5%
2010	1395	1.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
2013	47619	38.8%
2014	42059	34.3%
2012	24820	20.2%
2011	6743	5.5%
2010	1395	1.1%

Most occurring characters

Value	Count	Frequency (%)
2	147456	30.1%
1	129379	26.4%
0	124031	25.3%
3	47619	9.7%
4	42059	8.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	490544	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	147456	30.1%
1	129379	26.4%
0	124031	25.3%
3	47619	9.7%
4	42059	8.6%

Most occurring scripts

Value	Count	Frequency (%)
Common	490544	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	147456	30.1%
1	129379	26.4%
0	124031	25.3%
3	47619	9.7%
4	42059	8.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	490544	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	147456	30.1%
1	129379	26.4%
0	124031	25.3%
3	47619	9.7%
4	42059	8.6%

month_account_created
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.022562706

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	958.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	6
Q3	9
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.237813957
Coefficient of variation (CV)	0.5376139885
Kurtosis	-0.9600455487
Mean	6.022562706
Median Absolute Deviation (MAD)	3
Skewness	0.2565414262
Sum	738583
Variance	10.48343922
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
6	15787	12.9%
5	15100	12.3%
4	12793	10.4%
3	11475	9.4%
1	10048	8.2%
2	9465	7.7%
9	8530	7.0%
8	8315	6.8%
7	8030	6.5%
12	7880	6.4%
Other values (2)	15213	12.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	10048	8.2%
2	9465	7.7%
3	11475	9.4%
4	12793	10.4%
5	15100	12.3%
6	15787	12.9%
7	8030	6.5%
8	8315	6.8%
9	8530	7.0%
10	7617	6.2%

Value	Count	Frequency (%)
12	7880	6.4%
11	7596	6.2%
10	7617	6.2%
9	8530	7.0%
8	8315	6.8%
7	8030	6.5%
6	15787	12.9%
5	15100	12.3%
4	12793	10.4%
3	11475	9.4%

day_account_created
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.8485355

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	958.2 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	16
Q3	23
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.747581973
Coefficient of variation (CV)	0.5519489149
Kurtosis	-1.189826952
Mean	15.8485355
Median Absolute Deviation (MAD)	8
Skewness	-0.005988955419
Sum	1943601
Variance	76.52019038
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
24	4191	3.4%
16	4154	3.4%
23	4140	3.4%
20	4131	3.4%
18	4129	3.4%
28	4128	3.4%
27	4116	3.4%
12	4104	3.3%
11	4095	3.3%
10	4091	3.3%
Other values (21)	81357	66.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	3510	2.9%
2	3980	3.2%
3	3977	3.2%
4	3972	3.2%
5	4045	3.3%
6	4039	3.3%
7	3886	3.2%
8	3971	3.2%
9	4057	3.3%
10	4091	3.3%

Value	Count	Frequency (%)
31	2166	1.8%
30	3845	3.1%
29	3809	3.1%
28	4128	3.4%
27	4116	3.4%
26	4023	3.3%
25	3942	3.2%
24	4191	3.4%
23	4140	3.4%
22	4035	3.3%

day_of_week_account_created
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.756841384

Minimum	0
Maximum	6
Zeros	18949
Zeros (%)	15.5%
Negative	0
Negative (%)	0.0%
Memory size	958.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	3
Q3	4
95-th percentile	6
Maximum	6
Range	6
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.943418264
Coefficient of variation (CV)	0.704943808
Kurtosis	-1.148452726
Mean	2.756841384
Median Absolute Deviation (MAD)	2
Skewness	0.1708455936
Sum	338088
Variance	3.776874547
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
1	20245	16.5%
2	19662	16.0%
0	18949	15.5%
3	18632	15.2%
4	17119	14.0%
5	14027	11.4%
6	14002	11.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	18949	15.5%
1	20245	16.5%
2	19662	16.0%
3	18632	15.2%
4	17119	14.0%
5	14027	11.4%
6	14002	11.4%

Value	Count	Frequency (%)
6	14002	11.4%
5	14027	11.4%
4	17119	14.0%
3	18632	15.2%
2	19662	16.0%
1	20245	16.5%
0	18949	15.5%

week_of_year_account_created
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	53
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.38924949

Minimum	1
Maximum	53
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	958.2 KiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	13
median	23
Q3	36
95-th percentile	49
Maximum	53
Range	52
Interquartile range (IQR)	23

Descriptive statistics

Standard deviation	14.0251999
Coefficient of variation (CV)	0.5750566415
Kurtosis	-0.9463708598
Mean	24.38924949
Median Absolute Deviation (MAD)	11
Skewness	0.2578035502
Sum	2991000
Variance	196.7062322
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
26	3982	3.2%
25	3691	3.0%
21	3635	3.0%
24	3622	3.0%
23	3584	2.9%
20	3492	2.8%
22	3331	2.7%
18	3247	2.6%
19	3245	2.6%
17	3241	2.6%
Other values (43)	87566	71.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1919	1.6%
2	2286	1.9%
3	2451	2.0%
4	2243	1.8%
5	2286	1.9%
6	2375	1.9%
7	2282	1.9%
8	2375	1.9%
9	2552	2.1%
10	2514	2.0%

Value	Count	Frequency (%)
53	2	< 0.1%
52	1655	1.3%
51	1714	1.4%
50	1754	1.4%
49	1973	1.6%
48	1739	1.4%
47	1765	1.4%
46	1858	1.5%
45	1827	1.5%
44	1631	1.3%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	df_index	id	gender	age	signup_method	signup_flow	language	affiliate_channel	affiliate_provider	first_affiliate_tracked	signup_app	first_device_type	first_browser	country_destination	days_from_first_active_until_booking	days_from_first_active_until_account_created	days_from_account_created_until_first_booking	year_first_active	month_first_active	day_first_active	day_of_week_first_active	week_of_year_first_active	year_first_booking	month_first_booking	day_first_booking	day_of_week_first_booking	week_of_year_first_booking	year_account_created	month_account_created	day_account_created	day_of_week_account_created	week_of_year_account_created
0	1	820tgsjxq7	MALE	38	facebook	0	en	seo	google	untracked	Web	Mac Desktop	Chrome	NDF	2228	732	1496	2009	5	23	5	21	2015	6	29	0	27	2011	5	25	2	21
1	2	4ft3gnwmtx	FEMALE	56	basic	3	en	direct	direct	untracked	Web	Windows Desktop	IE	US	419	476	-57	2009	6	9	1	24	2010	8	2	0	31	2010	9	28	1	39
2	3	bjjt8pjhuk	FEMALE	42	facebook	0	en	direct	direct	untracked	Web	Mac Desktop	Firefox	other	1043	765	278	2009	10	31	5	44	2012	9	8	5	36	2011	12	5	0	49
3	4	87mebub9p4	-unknown-	41	basic	0	en	direct	direct	untracked	Web	Mac Desktop	Chrome	US	72	280	-208	2009	12	8	1	50	2010	2	18	3	7	2010	9	14	1	37
4	6	lsw9q7uk0j	FEMALE	46	basic	0	en	other	craigslist	untracked	Web	Mac Desktop	Safari	US	3	0	3	2010	1	2	5	53	2010	1	5	1	1	2010	1	2	5	53
5	7	0d01nltbrs	FEMALE	47	basic	0	en	direct	direct	omg	Web	Mac Desktop	Safari	US	10	0	10	2010	1	3	6	53	2010	1	13	2	2	2010	1	3	6	53
6	8	a1vcnhxeij	FEMALE	50	basic	0	en	other	craigslist	untracked	Web	Mac Desktop	Safari	US	206	0	206	2010	1	4	0	1	2010	7	29	3	30	2010	1	4	0	1
7	9	6uh8zyj2gn	-unknown-	46	basic	0	en	other	craigslist	omg	Web	Mac Desktop	Firefox	US	0	0	0	2010	1	4	0	1	2010	1	4	0	1	2010	1	4	0	1
8	10	yuuqmid2rp	FEMALE	36	basic	0	en	other	craigslist	untracked	Web	Mac Desktop	Firefox	US	2	0	2	2010	1	4	0	1	2010	1	6	2	1	2010	1	4	0	1
9	11	om1ss59ys8	FEMALE	47	basic	0	en	other	craigslist	untracked	Web	iPhone	-unknown-	NDF	2001	0	2001	2010	1	5	1	1	2015	6	29	0	27	2010	1	5	1	1

Last rows

	df_index	id	gender	age	signup_method	signup_flow	language	affiliate_channel	affiliate_provider	first_affiliate_tracked	signup_app	first_device_type	first_browser	country_destination	days_from_first_active_until_booking	days_from_account_created_until_first_booking	year_first_active	month_first_active	day_first_active	week_of_year_first_active	year_first_booking	month_first_booking	day_first_booking	day_of_week_first_booking	week_of_year_first_booking	year_account_created	month_account_created	day_account_created	week_of_year_account_created
122626	213425	l1f71f9vsj	FEMALE	30	facebook	0	en	direct	direct	linked	Web	Windows Desktop	Chrome	NDF	364	364	2014	6	30	27	2015	6	29	0	27	2014	6	30	27
122627	213430	79wk7k2k5t	-unknown-	19	basic	0	en	direct	direct	linked	Web	Mac Desktop	Chrome	NDF	364	364	2014	6	30	27	2015	6	29	0	27	2014	6	30	27
122628	213432	rg7ayg1tob	MALE	31	facebook	0	en	direct	direct	tracked-other	Web	Mac Desktop	Safari	NDF	364	364	2014	6	30	27	2015	6	29	0	27	2014	6	30	27
122629	213439	msucfwmlzc	MALE	43	basic	0	en	direct	direct	untracked	Web	Windows Desktop	Firefox	US	259	259	2014	6	30	27	2015	3	16	0	12	2014	6	30	27
122630	213440	04y8115avm	FEMALE	24	basic	25	en	direct	direct	untracked	iOS	iPhone	Mobile Safari	NDF	364	364	2014	6	30	27	2015	6	29	0	27	2014	6	30	27
122631	213441	omlc9iku7t	FEMALE	34	basic	0	en	direct	direct	linked	Web	Mac Desktop	Chrome	ES	44	44	2014	6	30	27	2014	8	13	2	33	2014	6	30	27
122632	213443	0k26r3mir0	FEMALE	36	basic	0	en	sem-brand	google	linked	Web	Mac Desktop	Safari	US	13	13	2014	6	30	27	2014	7	13	6	28	2014	6	30	27
122633	213445	qbxza0xojf	FEMALE	23	basic	0	en	sem-brand	google	omg	Web	Windows Desktop	IE	US	2	2	2014	6	30	27	2014	7	2	2	27	2014	6	30	27
122634	213446	zxodksqpep	MALE	32	basic	0	en	sem-brand	google	omg	Web	Mac Desktop	Safari	NDF	364	364	2014	6	30	27	2015	6	29	0	27	2014	6	30	27
122635	213448	6o3arsjbb4	-unknown-	32	basic	0	en	direct	direct	untracked	Web	Mac Desktop	Firefox	NDF	364	364	2014	6	30	27	2015	6	29	0	27	2014	6	30	27

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Dash Punctuation

Most occurring scripts